Ask
Login
TAGGED IN

Advanced Database Management Systems

Follow this tag to get notifications whenever a new post is added

ALL TAGS
0
votes
1
answer
2.2k
views
1
answer
Explain the Triggers in SQL with two examples
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
3.4k
views
1
answer
What is referential integrity? Explain with a suitable example.
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
1.7k
views
1
answer
Explain the deadlock
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
1.1k
views
1
answer
Explain Transaction, Lock point
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
1.7k
views
1
answer
What do you mean by serializability schedule? How would you test whether a given schedule S is conflict serializable?
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
1.3k
views
1
answer
Explain Time stamp based ordering
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
1.5k
views
1
answer
List ACID properties. Explain usefulness of each.
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
3.0k
views
1
answer
List ACID properties. Explain usefulness of each.
advanced database management systems updated 2.3 years ago by pedsangini276 • 4.8k
0
votes
1
answer
841
views
1
answer
Compare the shadow paging recovery scheme with the log-based recovery schemes in terms of ease of implementation and overhead cost.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.8k
1
vote
1
answer
2.2k
views
1
answer
Compare the shadow paging recovery scheme with the log-based recovery schemed in terms of ease of implementation and overhead cost.
advanced database management systems updated 2.2 years ago by pedsangini276 • 4.8k
1
vote
1
answer
5.2k
views
1
answer
Explain ETL phases in creating a data warehouse.
advanced database management systems updated 2.1 years ago by sagarkolekar ★ 11k
1
vote
1
answer
18k
views
1
answer
Explain with suitable e.g. object identity, object structure & type constructors in OODBs.
advanced database management systems updated 19 months ago by sagarkolekar ★ 11k
0
votes
1
answer
1.4k
views
1
answer
Explain deadlock in brief
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
5.0k
views
1
answer
Draw and explain database system structure.
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
6.7k
views
1
answer
Discuss Data Definition and Manipulation Commands in SQL.
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
4.3k
views
1
answer
Short notes on Data Control Commands in SQL
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
2
votes
1
answer
5.0k
views
1
answer
Write a note on views in SQL
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
2.0k
views
1
answer
What do you mean by serializability schedule? How would you test whether a given schedule S is conflict serializable?
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
6.5k
views
1
answer
Describe concurrency control based on timestamp ordering
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
3.4k
views
1
answer
Explain Time stamp based ordering
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
2.1k
views
1
answer
Compare the shadow paging recovery scheme with the log-based recovery schemes in terms of ease of implementation and overhead cost.
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
2.1k
views
1
answer
Explain B+-Trees Index files in DBMS.
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
4.1k
views
1
answer
Explain deadlock handling
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
4.6k
views
1
answer
When a transaction is rolled back under timestamp ordering, it is assigned a new timestamp, Why can it not simply keep its old timestamp?
advanced database management systems updated 2.5 years ago by binitamayekar ★ 6.4k
3
votes
1
answer
8.3k
views
1
answer
Write short note on checkpoint
advanced database management systems updated 2.5 years ago by pedsangini276 • 4.8k
<prev • 70 results • page 2 of 3 • next >